<?php
Class category_brand_model extends my_model {
	function __construct() {
		parent::__construct();
		$this->_prefix = "ctb";
		$this->_pk = "category_id";
		$this->_column = array(
								            'category_id' => $this->_prefix."_category_id",
								            'brand_id' => $this->_prefix."_brand_id"
			                     );
    $this->_join_column = array(
                            'id'      => "brand_id",
                            'name'    => "brand_name",
                            'date'    => "brand_date"
                );
	}

  function get($options = NULL){
    $this->db->join("ci_brand","ci_brand.brand_id = ci_category_brand.ctb_brand_id");
    $mainTable = parent::get($options);
    return $mainTable;
  }

}
?>